USE clothing 

go 

IF EXISTS(SELECT * 
          FROM   sys.objects 
          WHERE  object_id = Object_id(N'rewards_info') 
                 AND type IN ( N'U' )) 
  BEGIN 
      DROP TABLE rewards_info 
  END 

go 

CREATE TABLE rewards_info 
  ( 
     rid     INT IDENTITY(1, 1) NOT NULL, 
     eid     VARCHAR(10) NOT NULL, 
     rdate   VARCHAR(10) NOT NULL, 
     rtype   VARCHAR(5) NOT NULL, 
     reason  NVARCHAR(20), 
     score   INT        NOT NULL ,
     remarks NVARCHAR(200), 
     PRIMARY KEY CLUSTERED ( rid ASC )WITH (ignore_dup_key=OFF) ON [primary] 
  ) 
ON [primary] 

go 